home *** CD-ROM | disk | FTP | other *** search
- Path: news.tiac.net!not-for-mail
- From: dmeyer@tiac.net (David Meyer)
- Newsgroups: comp.sys.amiga.applications
- Subject: Re: TurboCalc
- Date: 19 Apr 1996 14:16:15 GMT
- Organization: The Internet Access Company
- Message-ID: <4l877f$eug@news.tiac.net>
- References: <w1gu3yg7krl.fsf@isleiv.ifi.uio.no>
- NNTP-Posting-Host: sunspot.tiac.net
- X-Newsreader: TIN [UNIX 1.3 950726BETA PL0]
-
- Uwe Sigurd Valentin Kubosch (uwek@isleiv.ifi.uio.no) wrote:
- : I need a field to be calculated as the cumulative sum of another
- : field like this:
- :
- : Field1 Field2
- :
- : 1 1
- : 2 3
- : 3 6
- : 4 10
- :
- : Except for a zillion if(;;)'s, is there a way to do this in
- : TurboCalc?
- :
- Hmmm, the first part is easy enough: SUM
-
- A B
- 1 1 1
- 2 2 3
- 3 3 6
-
- (you forgot the grid) The formula in B2 should be SUM(A$1:A2). Then copy
- this down the B column. The "A2" will increase by one at every row, the
- "A$1" will stay the same.
-